Friday, July 09, 2010
How to protect a range of cells in Open Office Excel
This info was not readily available so I thought let me share the same to enable easier access. This might be useful while preparing sheets where you would like to restrict access to certain cell ranges to avoid accidental change
- Open the OpenOffice Scalc document (excel of openoffice).
- Identify the range of cells to be un-protected. Open Office Calc documents will by default have all cells protected.
- Type Ctrl1. You will be at the Cell Protection options.
- Unmark Protected Option. now you have the range of cells as unprotected.
- OK
- Now go to Tools -> Protect Documents -> Sheet. (Alt T P S)
- Put a password to protect the sheet.
- Now you can edit all cells which have been unprotected while cannot edit the rest of the sheet.
- Save the sheet in relevant format. (do not change the format to MSexcel)
- Now you are good to go!!
Cheers
